<%@ Page Language="C#"%>
<%@ Import Namespace="SubSonic" %>
<%@ Import Namespace="SubSonic.CodeGenerator" %>
<%@ Import Namespace="System.Data" %>



<%foreach(DataProvider p in DataService.Providers){

      TableSchema.Table[] tables = DataService.GetTables(p.Name);
      TableSchema.Table[] views = DataService.GetViews(p.Name);

%>
Namespace <%=p.GeneratedNamespace%>
	#Region "Tables Struct"
	Public Partial Structure Tables
		Dim x As Integer
		<%
			foreach (TableSchema.Table t in tables)
			{
			    if(CodeService.ShouldGenerate(t.Name, p.Name))
			    {
%>
		Public Shared  <%= t.ClassName %> As String = "<%= t.TableName %>"
        <%
			    }
			}
%>
	End Structure
	#End Region

    #region "View Struct"
    Public Partial Structure Views
		Dim x As Integer
		<%
			foreach (TableSchema.Table v in views)
			{
				if (CodeService.ShouldGenerate(v.Name, p.Name))
				{
%>
		Public Shared <%= v.ClassName %> As String = "<%= v.TableName %>"
        <%
			}
		}
%>
    End Structure
    #End Region
End Namespace
<%} %>

#Region "Databases"
Public Partial Structure Databases
	Dim x As Integer
	<%foreach (DataProvider p in DataService.Providers) { %>
	Public Shared <%= p.Name %> As String = "<%= p.Name%>"
    <%}%>
End Structure
#End Region
